[dbo].[OrderCategory]

Property	Value
Created	10:31:30 AM Tuesday, March 02, 2010
Last Modified	11:40:05 AM Monday, February 20, 2012

Property

Value

Created

10:31:30 AM Tuesday, March 02, 2010

Last Modified

11:40:05 AM Monday, February 20, 2012

Name	Data Type	Max Length (Bytes)	Identity
OrderCategoryID	int	4	1 - 1
Title	varchar(64)	64
Description	varchar(1024)	1024
Active	bit	1
Header	varchar(512)	512
Footer	varchar(512)	512
Image	varchar(1024)	1024
SecurityKey	varchar(64)	64

Name

Data Type

Max Length (Bytes)

Allow Nulls

Identity

OrderCategoryID

int

1 - 1

Title

varchar(64)

Description

varchar(1024)

1024

Active

bit

Header

varchar(512)

512

Footer

varchar(512)

512

Image

varchar(1024)

1024

SecurityKey

varchar(64)

	Name	Columns	Unique
	PK_OrderCategory	OrderCategoryID

Name

Columns

Unique

PK_OrderCategory

OrderCategoryID

SQL Script

CREATE TABLE [dbo].[OrderCategory]
(
[OrderCategoryID] [int] NOT NULL IDENTITY(1, 1),
[Title] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Description] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Active] [bit] NOT NULL,
[Header] [varchar] (512) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Footer] [varchar] (512) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Image] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SecurityKey] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[OrderCategory] ADD CONSTRAINT [PK_OrderCategory] PRIMARY KEY CLUSTERED ([OrderCategoryID]) ON [PRIMARY]
GO